package org.wk.account.dao.zuan;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.wk.account.domain.zuan.SubAccountZuanLoginBill;
import org.wk.core.db.dao.GenericJpaRepository;


public interface SubAccountZuanLoginBillDao extends GenericJpaRepository<SubAccountZuanLoginBill, String>{

	@Query(nativeQuery=true,value="SELECT * FROM sub_account_zuan_login_bill WHERE user_id =:userId AND create_time >:dateTime")
	SubAccountZuanLoginBill findByUserIdAndDay(@Param("userId")String userId, @Param("dateTime") String dateTime);

	
}
